
--DROP TABLE [dbo].[StationData_Monthly_BULK]
CREATE TABLE [dbo].[StationData_Monthly_BULK](
	[year] [int] NULL,
	[month] [int] NULL,
	[meanmaxtemp] [decimal](4, 2) NULL,
	[meanmintemp] [decimal](4, 2) NULL,
	[meanmonthtemp] [decimal](4, 2) NULL,
	[extrmaxtemp] [decimal](4, 2) NULL,
	[extrmintemp] [decimal](4, 2) NULL,
	[totrain] [decimal](9, 2) NULL,
	[totsnow] [decimal](9, 2) NULL,
	[totprecip] [decimal](9, 2) NULL,
	[grndsnowlastday] [decimal](4, 2) NULL,
	[dirmaxgust] [decimal](9, 2) NULL,
	[speedmaxgust] [decimal](9, 2) NULL
)
GO



--DROP TABLE [dbo].[StationData_Monthly]
CREATE TABLE [dbo].[StationData_Monthly](
	[year] [int] NULL,
	[month] [int] NULL,
	[meanmaxtemp] [decimal](4, 2) NULL,
	[meanmintemp] [decimal](4, 2) NULL,
	[meanmonthtemp] [decimal](4, 2) NULL,
	[extrmaxtemp] [decimal](4, 2) NULL,
	[extrmintemp] [decimal](4, 2) NULL,
	[totrain] [decimal](9, 2) NULL,
	[totsnow] [decimal](9, 2) NULL,
	[totprecip] [decimal](9, 2) NULL,
	[grndsnowlastday] [decimal](4, 2) NULL,
	[dirmaxgust] [decimal](9, 2) NULL,
	[speedmaxgust] [decimal](9, 2) NULL
)
GO


/******************************************************************************
--DROP PROCEDURE dbo.s_Debug

******************************************************************************/
CREATE PROCEDURE [dbo].[s_Debug]
AS

SELECT * FROM dbo.StationData_Monthly_BULK
SELECT COUNT(*) FROM dbo.StationData_Monthly_BULK
--TRUNCATE TABLE dbo.StationData_Monthly_BULK


SELECT * FROM dbo.StationData_Monthly
SELECT COUNT(*) FROM dbo.StationData_Monthly
--TRUNCATE TABLE dbo.StationData_Monthly

GO
